//package com.lrkj.back.vo;
//
//import lombok.extern.log4j.Log4j;
//
///**
// * Created by john on 2017/11/10.
// */
//@Log4j
//public class Shoushushi {
//
//
//    private static final String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
//
//    private static final String URL = "jdbc:sqlserver://192.168.80.32:1433;DatabaseName=Healthone";//192.168.80.33
//
//    private static final String USERNAME = "pacs";//sa
//
//    private static final String PASSWORD = "pacs";//Admin321
//    //科室
//    private static final String SQL_DEPARTMENT = "select * from ss_department";
//    //员工
//    private static final String SQL_EMPLOYEE = "select * from ss_employee e, ss_department d where e.DEPARTMENT_NO=d.DEPARTMENT_NO";
//    //手术模板
//    private static final String SQL_FLOW_TEMPLATE = "select * from ss_operation_template";
//    //手术详情
//    private static final String SQL_FLOW_AND_PATIENT = "select * from ss_operation o,ss_patient p,ss_patient_hospital h , ss_department d where o.HOS_ID=h.HOS_ID and p.PATIENT_NO=h.PATIENT_NO and h.DEPT_NO=d.DEPARTMENT_NO";
//    //包模板
//    private static final String SQL_PACKAGE_TEMPLATE = "";
//    //器械模板
//    private static final String SQL_INSTRUMENT = "";
//    //手术具体医生
//    private static final String SQL_DOCTOR = "{call ss_Operation_doctor(?)}";
//    //手术具体模板
//    private static final String SQL_TEMPLATE_NO = "{ call  ss_Operation_detail(?)}";
//
//    private static Department department;
//    private static Employee employee;
//    private static Template template;
//    private static OperationAttend attend;
//    private static OperationArray operationArray;
//    private static Patient patient;
//    private static PatientHospitalization ph;
//    private static PackageProduct packageProduct;
//    private static PackageMuban packageMuban;
//    private static OperationFlow operationFlow;
//    private static FlowDetailVO flowDetailVO;
//
//    private static Connection con = null;
//    private static PreparedStatement ps = null;
//    private static ResultSet rs = null;
//
//    /**
//     * 获取数据库连接
//     *
//     * @return con
//     */
//    private static Connection getConnection() {
//        Connection conn = null;
//        try {
//            Class.forName(DRIVER).newInstance();
//            conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
//        } catch (InstantiationException e) {
//            e.printStackTrace();
//        } catch (IllegalAccessException e) {
//            e.printStackTrace();
//        } catch (ClassNotFoundException e) {
//            e.printStackTrace();
//        } catch (SQLException e) {
//            e.printStackTrace();
//        }
//        return conn;
//    }
//
//    /**
//     * 关闭数据库连接
//     */
//    private static void closeAll() {
//
//        try {
//            if (rs != null) {
//                rs.close();
//            }
//            if (ps != null) {
//                ps.close();
//            }
//            if (con != null) {
//                con.close();
//            }
//        } catch (SQLException e) {
//            e.printStackTrace();
//        }
//
//    }
//
//
//    /**
//     * 获取数据
//     *
//     * @param renheSql 枚举-查询条件
//     * @param t        数据类型(实例)
//     * @param <T>      泛型
//     * @return t集合
//     */
//    public synchronized static <T> List<T> getList(RenheSql renheSql, T t) {
//        List<T> list = null;
//        try {
//            con = getConnection();
//            ps = con.prepareStatement(renheSql.sql);
//            rs = ps.executeQuery();
//            list = createList(rs, t);
//        } catch (SQLException e) {
//            e.printStackTrace();
//        } finally {
//            closeAll();
//        }
//        return list;
//    }
//
//    private static ResultSet getCallBack(String sql, String param) {
//        try {
//            CallableStatement call = con.prepareCall(sql);
//            call.setString(1, param);
//            return call.executeQuery();
//        } catch (SQLException e) {
//            e.printStackTrace();
//        }
//        return null;
//    }
//
//    /**
//     * 封装数据
//     *
//     * @param rs  结果集
//     * @param t   数据类型
//     * @param <T> 泛型
//     * @return t集合
//     */
//    private static <T> List<T> createList(ResultSet rs, T t) {
//        try {
//            if (t instanceof Department) {
//                return (List<T>) createInfo(rs, department);
//            } else if (t instanceof Employee) {
//                return (List<T>) createInfo(rs, employee);
//            } else if (t instanceof Template) {
//                return (List<T>) createInfo(rs, template);
//            } else if (t instanceof PackageMuban) {
//                return (List<T>) createInfo(rs, packageMuban);
//            } else if (t instanceof PackageProduct) {
//                return (List<T>) createInfo(rs, packageProduct);
//            } else if (t instanceof FlowDetailVO) {
//                return (List<T>) createInfo(rs, flowDetailVO);
//            }
//        } catch (SQLException e) {
//            log.debug("获取" + t.getClass().getSimpleName() + "失败");
//        }
//        return null;
//    }
//
//    /**
//     * 封装手术详情
//     *
//     * @param rs           结果集
//     * @param flowDetailVO 手术详情
//     * @return 手术详情集合
//     */
//    private static List<FlowDetailVO> createInfo(ResultSet rs, FlowDetailVO flowDetailVO) throws SQLException {
//        List<FlowDetailVO> list = new ArrayList<>();
//        while (rs.next()) {
//            String tempNo = rs.getString("OPERATION_TEMP_ID");//主手术模板id
//            if(StringUtils.isBlank(tempNo)){
//                log.debug("描述型医嘱手术不操作");
//                continue;
//            }
//
//            flowDetailVO = new FlowDetailVO();
//            patient = new Patient();
//            ph = new PatientHospitalization();
//
//            //病人
//            patient.setPatientNo(rs.getString("PATIENT_NO"));
//            patient.setPatientName(rs.getString("PATIENT_NAME"));
//            Integer patientSex = rs.getInt("PATIENT_SEX");
//            patient.setPatientSex(patientSex == 1 ? "男" : patientSex == 2 ? "女" : "");
//            patient.setPatientAge(rs.getString("PATIENT_AGE"));
//            patient.setPatientAddress(rs.getString("PATIENT_ADDRESS"));
//            patient.setPatientIdNumber(rs.getString("PATIENT_ID_CARD"));
//            patient.setPatientMedicareNo(rs.getString("PATIENT_MEDICARE_CARD"));
//            patient.setPatientPayType(rs.getString("PATIENT_PAY_TYPE"));
//            patient.setPatientPhone(rs.getString("PATIENT_PHONE"));
//            patient.setPatientFamilyRelationship(rs.getString("PATIENT_RELATIVES_NAME"));
//            patient.setPatientFamilyPhone(rs.getString("PATIENT_RELATIVES_PHONE"));
//            //patient.setPatientVip(/*rs.getString("PATIENT_VIP")*/null);
//
//            //住院
//            ph.setPatientNo(patient.getPatientNo());
//            ph.setHosId(rs.getString("HOS_ID"));
//            ph.setParam1(rs.getString("PATIENT_WEIGHT"));
//            ph.setParam2(rs.getString("PATIENT_HEIGHT"));
//            ph.setHosBedNo(rs.getString("BED_NO"));
//            ph.setDeptNo(rs.getString("DEPT_NO"));
//            ph.setVisitId(rs.getString("zycs"));
//            String deptName = rs.getString("DEPARTMENT_NAME");
//            ph.setHosActionDoctor(rs.getString("MAIN_DOCTOR"));
//            ph.setHosActionDoctorNo(rs.getString("MAIN_DOCTOR_NO"));
//            //ph.setHosDiagnosis(rs.getString("HOS_DIAGNOSIS"));
//            //ph.setHosNurseRank();
//            ph.setParam1(rs.getString("NURSE_RANK"));
//            ph.setPatientName(patient.getPatientName());
//
//            //Flow
//            String type = rs.getString("OPERATION_APPLY_TYPE");
//            boolean b = checkFlowType(type);
//
//            //手术具体模板
//            String operation_main_id = rs.getString("Operation_main_id");//Operation_main_id
//            ResultSet callBack = getCallBack(SQL_TEMPLATE_NO, operation_main_id);
//
//            String operation_name = rs.getString("OPERATION_NAME");
//            String tempName = "";
//            String tempMainName = "";
//            while (callBack.next()) {
//                String no = callBack.getString("手术模版编号");
//                //callBack.getString("ICD编码");
//                String name = callBack.getString("手术模版名称");
//                //String id = callBack.getString("医嘱id");
//                if (StringUtils.isNotBlank(no)) {
//                    if (tempNo.contains(no)) {
//                        if (StringUtils.isNotBlank(name)) {
//                            tempMainName = name;
//                            continue;
//                        }
//                    } else {
//                        if (tempNo != null && !tempNo.equals("")) {
//                            tempNo = tempNo + "," + no;
//                        } else {
//                            tempNo = no;
//                        }
//                    }
//                }
//                if (StringUtils.isNotBlank(name)) {
//                    if (StringUtils.isNotBlank(tempName)) {
//                        tempName = tempName + "," + name;
//                    } else {
//                        tempName = name;
//                    }
//                }
//
//            }
//            callBack.close();
//            if (StringUtils.isNotBlank(tempMainName)) {
//                if (StringUtils.isNotBlank(tempName)) {
//                    tempName = tempMainName + "," + tempName;
//                } else {
//                    tempName = tempMainName;
//                }
//            }
//            if (tempName.equals("")) {
//                tempName = operation_name;
//            }
//
//
//            //手术具体医生
//            String applyId = rs.getString("OPERATION_APPLY_ID");
//            ResultSet callBack1 = getCallBack(SQL_DOCTOR, applyId);
//            String doc = null;
//            String docNo = null;
//            String docAides = null;
//            String docAidesNo = null;
//            while (callBack1.next()) {
//                String dNo = callBack1.getString("DNO");
//                String dName = callBack1.getString("DName");
//                String ace = callBack1.getString("ace01");
//                switch (ace) {
//                    case FlowDetailVO.DOCTOR:
//                        doc = dName;
//                        docNo = dNo;
//                        break;
//                    case FlowDetailVO.DOCTOR_AIDES:
//                        docAides = docAides==null ? dName : (docAides + "," + dName);
//                        docAidesNo = docAidesNo==null ? dNo : (docAidesNo + "," + dNo);
//                        break;
//                }
//            }
//            callBack1.close();
//
//
//            if (b) {
//                //排班
//                operationArray = new OperationArray();
//                operationArray.setOperationApplyId(applyId);
//                operationArray.setHosId(rs.getString("HOS_ID"));
//                operationArray.setDetpNo(rs.getString("DEPT_NO"));
//                operationArray.setDetpName(deptName);
//                operationArray.setBedNo(rs.getString("BED_NO"));
//                operationArray.setOperationTemplateNo(tempNo);
//                operationArray.setOperationTemplateName(tempName);
//                operationArray.setOperationRank(rs.getString("OPERATION_LEVEL"));
//                operationArray.setOperationDiagnosis(rs.getString("OPERATION_DIAGNOSIS"));
//
//                //operationArray.setOperationApplyDatetime(rs.getTimestamp("OPERATION_APPLY_TIME"));
//                operationArray.setOperationCreateTime(rs.getTimestamp("OPERATION_APPLY_TIME"));//手术申请的日期
//                operationArray.setOperationApplyDatetime(rs.getTimestamp("OPERATION_EFFTIME"));//手术时间
//
//                operationArray.setAnesthesiaScheme(rs.getString("ANESTHESIA_SCHEME"));
//                //operationArray.setOperationSensitivity(rs.getString("OPERATION_SENSITIVITY"));
//                operationArray.setOperationDoDept(rs.getString("OPERATION_DO_DEPT"));
//                operationArray.setOperationIsEmergency(type);
//                operationArray.setOperationPosition(rs.getString("OPERATION_POSITION"));
//                operationArray.setOperationRemark(rs.getString("OPERATION_REMARK"));
//                operationArray.setOperationDoc(doc);
//                operationArray.setOperationDocNo(docNo);
//                operationArray.setOperationAssistant(docAides);
//                operationArray.setOperationAssistantNo(docAidesNo);
//
//                //operationArray.setOperationEfftime(rs.getTimestamp("OPERATION_EFFTIME"));
//
//                operationArray.setUnplanedReoperation(rs.getInt("UNPLANED_REOPERATION"));
//                //operationArray.setOperationOther(rs.getString("OPERATION_OTHER"));
//
//                operationArray.setPatientName(patient.getPatientName());
//                operationArray.setPatientId(patient.getPatientNo());
//                operationArray.setPatientSex(patient.getPatientSex());
//                operationArray.setPatientAge(patient.getPatientAge());
//
//                flowDetailVO.setApplyId(operationArray.getOperationApplyId());
//            } else {
//                //手术流程
//                operationFlow = new OperationFlow();
//                operationFlow.setOperationApplyId(applyId);
//                operationFlow.setHosId(rs.getString("HOS_ID"));
//                operationFlow.setDetpNo(rs.getString("DEPT_NO"));
//                operationFlow.setDetpName(deptName);
//                operationFlow.setBedNo(rs.getString("BED_NO"));
//                operationFlow.setOperationTemplateId(tempNo);
//                operationFlow.setOperationName(tempName);
//                operationFlow.setOperationRank(rs.getString("OPERATION_LEVEL"));
//                operationFlow.setOperationDiagnosis(rs.getString("OPERATION_DIAGNOSIS"));
//                operationFlow.setOperationApplyDatetime(rs.getTimestamp("OPERATION_APPLY_TIME"));
//                operationFlow.setOperationAnaesthesia(rs.getString("ANESTHESIA_SCHEME"));
//                //operationFlow.setOperationQuick(rs.getString("OPERATION_SENSITIVITY"));
//                operationFlow.setPatientDepartementId(rs.getString("OPERATION_DO_DEPT"));
//                operationFlow.setOperationIsEmergency(type);
//                operationFlow.setOperationPosition(rs.getString("OPERATION_POSITION"));
//                operationFlow.setOperationMark(rs.getString("OPERATION_REMARK"));
//                operationFlow.setOperationDoc(doc);
//                operationFlow.setOperationDocAide(docAides);
//                operationFlow.setOperationEfftime(rs.getTimestamp("OPERATION_EFFTIME"));
//                operationFlow.setUnplanedReoperation(rs.getInt("UNPLANED_REOPERATION"));
//                //operationFlow.setOperationOther(rs.getString("OPERATION_OTHER"));
//
//                operationFlow.setPatientId(patient.getPatientNo());
//                operationFlow.setPatientName(patient.getPatientName());
//                operationFlow.setPatientAge(patient.getPatientAge());
//                operationFlow.setPatientSex(patient.getPatientSex());
//                operationFlow.setOperationCreateTime(rs.getTimestamp("OPERATION_APPLY_TIME"));
//
//                //医护
//                attend = new OperationAttend();
//                attend.setOperationApplyid(operationFlow.getOperationApplyId());
//                attend.setOperationDoc(operationFlow.getOperationDoc());
//                attend.setOperationDocNo(docNo);
//                String[] aides = docAides.split(",");
//                if (aides.length > 0) {
//                    attend.setOperationDocOne(aides[0]);
//                }
//                if (aides.length > 1) {
//                    attend.setOperationDocTwo(aides[1]);
//                }
//                if (aides.length > 2) {
//                    attend.setOperationDocThr(aides[2]);
//                }
//                String[] aidesNo = docAidesNo.split(",");
//                if (aidesNo.length > 0) {
//                    attend.setOperationDocOneNo(aidesNo[0]);
//                }
//                if (aidesNo.length > 1) {
//                    attend.setOperationDocTwoNo(aidesNo[1]);
//                }
//                if (aidesNo.length > 2) {
//                    attend.setOperationDocThrNo(aidesNo[2]);
//                }
//                flowDetailVO.setApplyId(operationFlow.getOperationApplyId());
//            }
//
//            Integer operation_st = rs.getInt("Operation_st");//手术状态
//            Integer patient_st = rs.getInt("PATIENT_ST");//病人状态 1=入院，2=在院，4=欲出院
//
//            flowDetailVO.setState(operation_st);
//            flowDetailVO.setPatient(patient);
//            flowDetailVO.setPh(ph);
//            flowDetailVO.setOperationArray(operationArray);
//            flowDetailVO.setOperationAttend(attend);
//            flowDetailVO.setFlow(operationFlow);
//            flowDetailVO.setEmergency(!b);
//            list.add(flowDetailVO);
//        }
//        return list;
//    }
//
//    /**
//     * 判断手术不是急诊
//     *
//     * @param type 手术类型
//     * @return true/false
//     */
//    private static boolean checkFlowType(String type) {
//        return StringUtils.isBlank(type) || type.equals(Table.OperationArray.OperationIsEmergency.ISEMERGENCY_0);
//    }
//
//    /**
//     * 封装器械
//     *
//     * @param rs             结果集
//     * @param packageProduct 器械
//     * @return 该类型集合
//     */
//    private static List<PackageProduct> createInfo(ResultSet rs, PackageProduct packageProduct) throws SQLException {
//        List<PackageProduct> list = new ArrayList<>();
//        while (rs.next()) {
//            packageProduct = new PackageProduct();
//            packageProduct.setPrNo(rs.getString("INSTRUMENT_NO"));
//            packageProduct.setPrName(rs.getString("INSTRUMENT_NAME"));
//            packageProduct.setPrType3(rs.getString("INSTRUMENT_TYPE"));
//            packageProduct.setPrSize(rs.getString("INSTRUMENT_SIZE1"));
//            packageProduct.setParam1(rs.getString("INSTRUMENT_SIZE2"));
//            packageProduct.setPrFunction(rs.getString("INSTRUMENT_MARK"));
//            list.add(packageProduct);
//        }
//        return list;
//    }
//
//    /**
//     * 封装包模板
//     *
//     * @param rs           结果集
//     * @param packageMuban 包模板
//     * @return 该类型集合
//     */
//    private static List<PackageMuban> createInfo(ResultSet rs, PackageMuban packageMuban) throws SQLException {
//        List<PackageMuban> list = new ArrayList<>();
//        while (rs.next()) {
//            packageMuban = new PackageMuban();
//            packageMuban.setPackageNo(rs.getString("PACKAGE_TEMPLATE_NO"));
//            packageMuban.setPackageTypeTri(rs.getString("PACKAGE_TYPE"));
//            packageMuban.setPackageName(rs.getString("PACKAGE_NAME"));
//            packageMuban.setPackageDepartNo(rs.getString("PACKAGE_DEPT_NO"));
//            packageMuban.setPackageFunction(rs.getString("PACKAGE_REF"));
//            packageMuban.setPackageSize(rs.getString("PACKAGE_SIZE"));
//            packageMuban.setPackageText(rs.getString("PACKAGE_MIEJUN_FANGSHI"));//灭菌
//            list.add(packageMuban);
//        }
//        return list;
//    }
//
//    /**
//     * 封装手术模板
//     *
//     * @param rs       结果集
//     * @param template 手术模板
//     * @return 该类型集合
//     */
//    private static List<Template> createInfo(ResultSet rs, Template template) throws SQLException {
//        List<Template> list = new ArrayList<>();
//        while (rs.next()) {
//            template = new Template();
//            template.setOperationTemplateId(rs.getString("OPERATION_TEMPLATE_ID"));
//            template.setDepartNo(rs.getString("DEPART_NO"));
//            //template.setOperationRoomLevel(/*rs.getInt("OPERATION_ROOM_LEVEL")*/null);
//            //template.setTemplateTypeOne(/*rs.getInt("TEMPLATE_TYPE_ONE")*/null);
//            template.setOperationNo(rs.getString("OPERATION_NO"));
//            template.setOperationName(rs.getString("OPERATION_NAME"));
//            //template.setOperationCode(rs.getString("OPERATION_CODE"));
//            //template.setOperationPostion(rs.getString("OPERATION_POSTION"));
//            template.setOperationLevel(rs.getInt("OPERATION_LEVEL"));
//            //template.setOperationIncision(rs.getString("OPERATION_INCISION"));
//            //template.setOperationIncisionLevel(/*rs.getInt("OPERATION_INCISION_LEVEL")*/null);
//            //template.setOperationAnaesthesia(rs.getString("OPERATION_ANAESTHESIA"));
//            //template.setOperationUseTime(/*rs.getInt("OPERATION_USE_TIME")*/null);
//            template.setOperationMark(rs.getString("OPERATION_MARK"));
//            list.add(template);
//        }
//        return list;
//    }
//
//    /**
//     * 封装科室
//     *
//     * @param rs         结果集
//     * @param department 科室
//     * @return 该类型集合
//     */
//    private static List<Department> createInfo(ResultSet rs, Department department) throws SQLException {
//        List<Department> list = new ArrayList<>();
//        while (rs.next()) {
//            department = new Department();
//            department.setDepartmentNo(rs.getString("DEPARTMENT_NO"));
//            department.setDepartmentName(rs.getString("DEPARTMENT_NAME"));
//            department.setDepartmentTel(rs.getString("DEPARTMENT_TEL"));
//            //department.setDepartmentManNo(rs.getString("DEPARTMENT_MAN_NO"));
//            //department.setDepartmentManTel(rs.getString("DEPARTMENT_MAN_TEL"));
//            department.setParam1(rs.getString("code"));
//            list.add(department);
//        }
//        return list;
//    }
//
//    /**
//     * 封装员工
//     *
//     * @param rs       结果集
//     * @param employee 员工
//     * @return 该类型集合
//     */
//    private static List<Employee> createInfo(ResultSet rs, Employee employee) throws SQLException {
//        List<Employee> list = new ArrayList<>();
//        while (rs.next()) {
//            employee = new Employee();
//            employee.setEmployeeId(rs.getString("EMPLOYEE_ID"));
//            employee.setDepartmentNo(rs.getString("DEPARTMENT_NO"));
//            employee.setDepartmentName(rs.getString("DEPARTMENT_NAME"));
//            employee.setEmployeeLoginName(rs.getString("EMPLOYEE_NO"));
//            employee.setEmployeeName(rs.getString("EMPLOYEE_NAME"));
//            //String age = rs.getString("EMPLOYEE_AGE");
//            //employee.setEmployeeAge(age.equals("") ? null : Integer.valueOf(age));
//            String sex = rs.getString("EMPLOYEE_SEX");
//            employee.setEmployeeSex(sex.equals("1") ? 1 : sex.equals("2") ? 0 : null);
//            employee.setEmployeeCard(rs.getString("EMPLOYEE_CARD"));
//            //employee.setEmployeeAddress(rs.getString("EMPLOYEE_ADDRESS"));
//            //employee.setEmployeeTel(rs.getString("EMPLOYEE_TEL"));
//            Integer state = rs.getInt("EMPLOYEE_STATE");
//            employee.setEmployeeState(state == 1 ? 1 : state == 2 ? 0 : 3);
//            /*String employee_createtime = rs.getString("EMPLOYEE_CREATETIME");*/
//            //employee.setEmployeeCreatetime(null);
//            employee.setEmployeeType(rs.getString("EMPLOYEE_TYPE"));
//            employee.setParam1(employee.getEmployeeType());
//            list.add(employee);
//        }
//        return list;
//    }
//
//    /**
//     * 获取基础信息
//     *
//     * @return
//     */
//    public static BaseInfoVO getBaseList() {
//        BaseInfoVO baseInfoVO = new BaseInfoVO();
//        List<Department> departments = getList(RenheSql.DEPARTMENT, new Department());
//        //his没有
//        /*List<PackageMuban> packageMubans = getList(RenheSql.PACKAGE_TEMPLATE, new PackageMuban());
//        List<PackageProduct> packageProducts = getList(RenheSql.INSTRUMENT, new PackageProduct());*/
//        List<Template> templates = getList(RenheSql.TEMPLATE, new Template());
//        List<Employee> employees = getList(RenheSql.EMPLOYEE, new Employee());
//        baseInfoVO.setDepartments(departments);
//        /*baseInfoVO.setPackageMubans(packageMubans);
//        baseInfoVO.setPackageProducts(packageProducts);*/
//        baseInfoVO.setTemplates(templates);
//        baseInfoVO.setEmployees(employees);
//        return baseInfoVO;
//    }
//
//    /**
//     * 获取手术信息
//     *
//     * @return
//     */
//    public static List<FlowDetailVO> getFlowDetail() {
//        return getList(RenheSql.FLOW_DETAIL, new FlowDetailVO());
//    }
//
//
//    public enum RenheSql {
//        DEPARTMENT(SQL_DEPARTMENT),
//        PACKAGE_TEMPLATE(SQL_PACKAGE_TEMPLATE),
//        INSTRUMENT(SQL_INSTRUMENT),
//        TEMPLATE(SQL_FLOW_TEMPLATE),
//        EMPLOYEE(SQL_EMPLOYEE),
//        FLOW_DETAIL(SQL_FLOW_AND_PATIENT);
//
//        private final String sql;
//
//        RenheSql(final String sql) {
//            this.sql = sql;
//        }
//
//    }
//
//    public static void main(String[] args) {
//        List<FlowDetailVO> flowDetail = getFlowDetail();
//        log.info(flowDetail);
//        /*BaseInfoVO baseList = getBaseList();
//        log.info(baseList);*/
//    }
//}
